IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'CompaniesGetByUserID')
	BEGIN
		DROP  Procedure  CompaniesGetByUserID
	END

GO

CREATE Procedure CompaniesGetByUserID
(
	@UserID int
)
AS

SELECT CompanyID
	, CompanyName
	, URL
	, Symbol
	, Exchange
FROM Companies
WHERE UserID = @userID

GO

